import java.sql.Connection;
import java.sql.DriverManager;

import jade.core.*;
import jade.core.behaviours.*;
import javax.swing.JOptionPane;

public class Conectare extends Agent{
	
	 String url1 = "jdbc:odbc:athenahospital";
	 String url2 = "jdbc:odbc:smurdhospital";
	
	public Connection getConnection() throws SQLException, java.sql.SQLException {
		Connection con = null;
		
	        try {
	            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	        } catch (ClassNotFoundException e) {
	            System.out.println(e);
	        }
	        con = DriverManager.getConnection(url1, "", "");
			con = DriverManager.getConnection(url2, "", "");
		return con;
	}
	
}

